SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE procedure dbo.DnnProduct_DeleteRole

@RoleId int

as

delete 
from dbo.DnnProduct_FolderPermission
where  RoleId = @RoleId

delete 
from dbo.DnnProduct_ModulePermission
where  RoleId = @RoleId

delete 
from dbo.DnnProduct_TabPermission
where  RoleId = @RoleId

delete 
from dbo.DnnProduct_Roles
where  RoleId = @RoleId




GO
